CREATE TABLE `${entity.underlineName}` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
<#list entity.properties as property>
    <#if property.javaType?? && 'String' = property.javaType >
`${property.underlinePropertyName}` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '${property.describe}',
    <#elseif property.javaType?? && 'Integer' == property.javaType >
`${property.underlinePropertyName}` int(11) COMMENT '${property.describe}',
    <#elseif property.javaType?? && 'Boolean' == property.javaType >
`${property.underlinePropertyName}` tinyint(1) NOT NULL DEFAULT '0' COMMENT '${property.describe}',
    <#elseif property.javaType?? && 'Double' == property.javaType >
`${property.underlinePropertyName}` double(11) COMMENT '${property.describe}',
    <#elseif property.javaType?? && 'Long' == property.javaType >
`${property.underlinePropertyName}` bigint(20) COMMENT '${property.describe}',
    <#elseif property.javaType?? && 'BigDecimal' == property.javaType >
`${property.underlinePropertyName}` decimal(12,2) COMMENT '${property.describe}',
    <#elseif property.javaType?? && 'LocalDate' == property.javaType >
`${property.underlinePropertyName}` date COMMENT '${property.describe}',
    <#elseif property.javaType?? && 'LocalDateTime' == property.javaType >
`${property.underlinePropertyName}` datetime COMMENT '${property.describe}',
    <#elseif property.javaType?? && 'LocalTime' == property.javaType >
`${property.underlinePropertyName}` time COMMENT '${property.describe}',
    </#if>
</#list>
`del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除(默认fasle)',
`creator` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modifier` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人',
`modify_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='${entity.describe}';